subscribers

Dataset statistics

Number of variables	28
Number of observations	191563
Missing cells	708906
Missing cells (%)	13.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.1 MiB
Average record size in memory	203.0 B

Variable types

CAT	15
NUM	9
BOOL	4

Warnings

`account_creation_date` has a high cardinality: 190383 distinct values	High cardinality
`trial_end_date` has a high cardinality: 190383 distinct values	High cardinality
`last_payment` has a high cardinality: 106702 distinct values	High cardinality
`next_payment` has a high cardinality: 104772 distinct values	High cardinality
`cancel_date` has a high cardinality: 284 distinct values	High cardinality
`discount_price` is highly correlated with `monthly_price` and 1 other fields	High correlation
`monthly_price` is highly correlated with `discount_price` and 1 other fields	High correlation
`num_trial_days` is highly correlated with `monthly_price` and 1 other fields	High correlation
`num_trial_days` is highly correlated with `plan_type`	High correlation
`plan_type` is highly correlated with `num_trial_days`	High correlation
`package_type` has 35361 (18.5%) missing values	Missing
`num_weekly_services_utilized` has 74802 (39.0%) missing values	Missing
`preferred_genre` has 36107 (18.8%) missing values	Missing
`intended_use` has 3502 (1.8%) missing values	Missing
`weekly_consumption_hour` has 2755 (1.4%) missing values	Missing
`num_ideal_streaming_services` has 76518 (39.9%) missing values	Missing
`attribution_survey` has 2602 (1.4%) missing values	Missing
`op_sys` has 12986 (6.8%) missing values	Missing
`payment_type` has 134856 (70.4%) missing values	Missing
`last_payment` has 84275 (44.0%) missing values	Missing
`next_payment` has 86098 (44.9%) missing values	Missing
`cancel_date` has 159040 (83.0%) missing values	Missing
`monthly_price` is highly skewed (γ1 = -32.62319544)	Skewed
`discount_price` is highly skewed (γ1 = -31.4084658)	Skewed
`account_creation_date` is uniformly distributed	Uniform
`trial_end_date` is uniformly distributed	Uniform
`last_payment` is uniformly distributed	Uniform
`next_payment` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`subid` has unique values	Unique
`join_fee` has 33089 (17.3%) zeros	Zeros

Reproduction

Analysis started	2020-12-12 13:51:22.668997
Analysis finished	2020-12-12 13:53:04.349768
Duration	1 minute and 41.68 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	191563
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	113752.0782
Minimum	1
Maximum	227627
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	11325.1
Q1	56788.5
median	113852
Q3	170635.5
95-th percentile	216214.9
Maximum	227627
Range	227626
Interquartile range (IQR)	113847

Descriptive statistics

Standard deviation	65738.24676
Coefficient of variation (CV)	0.5779080943
Kurtosis	-1.200385816
Mean	113752.0782
Median Absolute Deviation (MAD)	56920
Skewness	-0.0005193121325
Sum	2.179068936e+10
Variance	4321517087
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4094	1	< 0.1%
75150	1	< 0.1%
105881	1	< 0.1%
103832	1	< 0.1%
126359	1	< 0.1%
128404	1	< 0.1%
118163	1	< 0.1%
116114	1	< 0.1%
122257	1	< 0.1%
120208	1	< 0.1%
Other values (191553)	191553	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
227627	1	< 0.1%
227625	1	< 0.1%
227624	1	< 0.1%
227623	1	< 0.1%
227622	1	< 0.1%

subid
Real number (ℝ_≥0)

UNIQUE

Distinct	191563
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	24986379
Minimum	20000009
Maximum	29999982
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	20000009
5-th percentile	20499195.7
Q1	22490128.5
median	24971020
Q3	27487834.5
95-th percentile	29491790.3
Maximum	29999982
Range	9999973
Interquartile range (IQR)	4997706

Descriptive statistics

Standard deviation	2883893.76
Coefficient of variation (CV)	0.1154186351
Kurtosis	-1.198724491
Mean	24986379
Median Absolute Deviation (MAD)	2498988
Skewness	0.008486716085
Sum	4.78646572e+12
Variance	8.316843222e+12
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24643583	1	< 0.1%
26322192	1	< 0.1%
23442816	1	< 0.1%
20217253	1	< 0.1%
20550169	1	< 0.1%
24399267	1	< 0.1%
23348642	1	< 0.1%
20738546	1	< 0.1%
20207008	1	< 0.1%
22212172	1	< 0.1%
Other values (191553)	191553	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20000009	1	< 0.1%
20000048	1	< 0.1%
20000062	1	< 0.1%
20000094	1	< 0.1%
20000104	1	< 0.1%

Value	Count	Frequency (%)
29999982	1	< 0.1%
29999945	1	< 0.1%
29999904	1	< 0.1%
29999879	1	< 0.1%
29999862	1	< 0.1%

package_type
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	35361
Missing (%)	18.5%
Memory size	1.5 MiB

base	86886
enhanced	53373
economy	15943

Frequencies
Length

Value	Count	Frequency (%)
base	86886	45.4%
enhanced	53373	27.9%
economy	15943	8.3%
(Missing)	35361	18.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	4
Mean length	5.179559727
Min length	3

num_weekly_services_utilized
Real number (ℝ_≥0)

MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	74802
Missing (%)	39.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.008984164
Minimum	0
Maximum	14
Zeros	2
Zeros (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	3
95-th percentile	5
Maximum	14
Range	14
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8208150659
Coefficient of variation (CV)	0.2727880976
Kurtosis	2.353599881
Mean	3.008984164
Median Absolute Deviation (MAD)	0
Skewness	1.023508238
Sum	351332
Variance	0.6737373725
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	63701	33.3%
2	29670	15.5%
4	17269	9.0%
5	5016	2.6%
6	904	0.5%
7	138	0.1%
1	24	< 0.1%
8	22	< 0.1%
9	11	< 0.1%
10	3	< 0.1%
Other values (2)	3	< 0.1%
(Missing)	74802	39.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	24	< 0.1%
2	29670	15.5%
3	63701	33.3%
4	17269	9.0%

Value	Count	Frequency (%)
14	1	< 0.1%
10	3	< 0.1%
9	11	< 0.1%
8	22	< 0.1%
7	138	0.1%

preferred_genre
Categorical

MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	36107
Missing (%)	18.8%
Memory size	1.5 MiB

comedy	97258
drama	39939
regional	8418
international	6063
other	3778

Frequencies
Length

Value	Count	Frequency (%)
comedy	97258	50.8%
drama	39939	20.8%
regional	8418	4.4%
international	6063	3.2%
other	3778	2.0%
(Missing)	36107	18.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	6
Mean length	5.515767659
Min length	3

intended_use
Categorical

MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	3502
Missing (%)	1.8%
Memory size	1.5 MiB

access to exclusive content	69727
replace OTT	56278
supplement OTT	23233
expand regional access	13941
expand international access	12929
Other values (2)	11953

Frequencies
Length

Value	Count	Frequency (%)
access to exclusive content	69727	36.4%
replace OTT	56278	29.4%
supplement OTT	23233	12.1%
expand regional access	13941	7.3%
expand international access	12929	6.7%
other	6849	3.6%
education	5104	2.7%
(Missing)	3502	1.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	27
Median length	22
Mean length	18.65402505
Min length	3

weekly_consumption_hour
Real number (ℝ)

MISSING

Distinct	81
Distinct (%)	< 0.1%
Missing	2755
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%

Mean	28.00112139
Minimum	-32.1467596
Maximum	76.59996225
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	-32.1467596
5-th percentile	21.50162318
Q1	24.40153577
median	27.30144835
Q3	30.20136093
95-th percentile	37.45114239
Maximum	76.59996225
Range	108.7467219
Interquartile range (IQR)	5.799825165

Descriptive statistics

Standard deviation	4.977112143
Coefficient of variation (CV)	0.1777468864
Kurtosis	3.173344778
Mean	28.00112139
Median Absolute Deviation (MAD)	2.899912583
Skewness	0.6404438306
Sum	5286835.728
Variance	24.77164528
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.85149206	25863	13.5%
28.75140464	22848	11.9%
27.30144835	22436	11.7%
24.40153577	19869	10.4%
30.20136093	18298	9.6%
22.95157947	16732	8.7%
31.65131722	13199	6.9%
33.10127351	9378	4.9%
21.50162318	8665	4.5%
34.5512298	7398	3.9%
Other values (71)	24122	12.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-32.1467596	1	< 0.1%
-29.24684701	4	< 0.1%
-27.79689072	1	< 0.1%
-23.44702185	1	< 0.1%
-13.29732781	1	< 0.1%

Value	Count	Frequency (%)
76.59996225	3	< 0.1%
75.15000596	3	< 0.1%
73.70004967	1	< 0.1%
72.25009338	5	< 0.1%
67.90022451	5	< 0.1%

num_ideal_streaming_services
Real number (ℝ)

MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	76518
Missing (%)	39.9%
Infinite	0
Infinite (%)	0.0%

Mean	2.061262984
Minimum	-1
Maximum	7
Zeros	4
Zeros (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-1
5-th percentile	2
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	7
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2459331339
Coefficient of variation (CV)	0.1193118665
Kurtosis	14.18847432
Mean	2.061262984
Median Absolute Deviation (MAD)	0
Skewness	3.601336973
Sum	237138
Variance	0.06048310636
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	107857	56.3%
3	7047	3.7%
1	89	< 0.1%
4	42	< 0.1%
5	4	< 0.1%
0	4	< 0.1%
7	1	< 0.1%
-1	1	< 0.1%
(Missing)	76518	39.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	1	< 0.1%
0	4	< 0.1%
1	89	< 0.1%
2	107857	56.3%
3	7047	3.7%

Value	Count	Frequency (%)
7	1	< 0.1%
5	4	< 0.1%
4	42	< 0.1%
3	7047	3.7%
2	107857	56.3%

age
Real number (ℝ_≥0)

Distinct	95
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.15751248
Minimum	0
Maximum	90
Zeros	64
Zeros (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	24
Q1	35
median	46
Q3	57
95-th percentile	70
Maximum	90
Range	90
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.97657738
Coefficient of variation (CV)	0.3028017895
Kurtosis	-0.7493570161
Mean	46.15751248
Median Absolute Deviation (MAD)	11
Skewness	0.08003035382
Sum	8842071.563
Variance	195.3447151
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	6355	3.3%
40	5509	2.9%
60	5221	2.7%
48	4651	2.4%
47	4517	2.4%
55	4509	2.4%
49	4483	2.3%
52	4440	2.3%
43	4357	2.3%
42	4346	2.3%
Other values (85)	143175	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	64	< 0.1%
10	3	< 0.1%
16	1	< 0.1%
18	1097	0.6%
19	632	0.3%

Value	Count	Frequency (%)
90	2	< 0.1%
89	7	< 0.1%
88	8	< 0.1%
87	13	< 0.1%
86	14	< 0.1%

male_TF
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	1.5 MiB

False	166771
True	24788
(Missing)	4

Common Values
Chart

Value	Count	Frequency (%)
False	166771	87.1%
True	24788	12.9%
(Missing)	4	< 0.1%

attribution_technical
Categorical

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

facebook	62809
search	22080
email	21109
organic	18683
brand sem intent google	15821
Other values (28)	51061

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
facebook	62809	32.8%
search	22080	11.5%
email	21109	11.0%
organic	18683	9.8%
brand sem intent google	15821	8.3%
google_organic	9553	5.0%
affiliate	9318	4.9%
email_blast	6321	3.3%
pinterest	5634	2.9%
referral	4005	2.1%
Other values (23)	16230	8.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	23
Median length	8
Mean length	9.270464547
Min length	2

attribution_survey
Categorical

MISSING

Distinct	16
Distinct (%)	< 0.1%
Missing	2602
Missing (%)	1.4%
Memory size	1.5 MiB

facebook	93584
tv	34737
referral	17102
search	8084
pinterest	7393
Other values (11)	28061

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
facebook	93584	48.9%
tv	34737	18.1%
referral	17102	8.9%
search	8084	4.2%
pinterest	7393	3.9%
other	6423	3.4%
public_radio	5897	3.1%
social_organic	3735	1.9%
youtube	3086	1.6%
podcast	2921	1.5%
Other values (6)	5999	3.1%
(Missing)	2602	1.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	16
Median length	8
Mean length	6.926488936
Min length	2

op_sys
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	12986
Missing (%)	6.8%
Memory size	1.5 MiB

iOS	116419
Android	62158

Frequencies
Length

Value	Count	Frequency (%)
iOS	116419	60.8%
Android	62158	32.4%
(Missing)	12986	6.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	3
Mean length	4.297912436
Min length	3

plan_type
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

base_uae_14_day_trial	191032
high_uae_14_day_trial	325
low_uae_no_trial	166
base_eur_14_day_trial	18
high_sar_14_day_trial	12
Other values (6)	10

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
base_uae_14_day_trial	191032	99.7%
high_uae_14_day_trial	325	0.2%
low_uae_no_trial	166	0.1%
base_eur_14_day_trial	18	< 0.1%
high_sar_14_day_trial	12	< 0.1%
low_gbp_14_day_trial	4	< 0.1%
high_aud_14_day_trial	2	< 0.1%
high_jpy_14_day_trial	1	< 0.1%
base_uae_no_trial_7_day_guarantee	1	< 0.1%
low_eur_no_trial	1	< 0.1%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	33
Median length	21
Mean length	20.99565678
Min length	16

monthly_price
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.731644867
Minimum	0.8074
Maximum	5.1013
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0.8074
5-th percentile	4.7343
Q1	4.7343
median	4.7343
Q3	4.7343
95-th percentile	4.7343
Maximum	5.1013
Range	4.2939
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1098266661
Coefficient of variation (CV)	0.0232110966
Kurtosis	1088.933009
Mean	4.731644867
Median Absolute Deviation (MAD)	0
Skewness	-32.62319544
Sum	906408.0856
Variance	0.01206189658
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
4.7343	191037	99.7%
5.1013	325	0.2%
1.0643	166	0.1%
4.4407	18	< 0.1%
4.3673	12	< 0.1%
4.0003	2	< 0.1%
1.1744	1	< 0.1%
0.8074	1	< 0.1%
4.6976	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.8074	1	< 0.1%
1.0643	166	0.1%
1.1744	1	< 0.1%
4.0003	2	< 0.1%
4.3673	12	< 0.1%

Value	Count	Frequency (%)
5.1013	325	0.2%
4.7343	191037	99.7%
4.6976	1	< 0.1%
4.4407	18	< 0.1%
4.3673	12	< 0.1%

discount_price
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.511846805
Minimum	0.7707
Maximum	5.0279
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0.7707
5-th percentile	4.5141
Q1	4.5141
median	4.5141
Q3	4.5141
95-th percentile	4.5141
Maximum	5.0279
Range	4.2572
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.105518673
Coefficient of variation (CV)	0.02338702478
Kurtosis	1041.714144
Mean	4.511846805
Median Absolute Deviation (MAD)	0
Skewness	-31.4084658
Sum	864302.9096
Variance	0.01113419036
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4.5141	191032	99.7%
5.0279	325	0.2%
1.0276	166	0.1%
4.2205	18	< 0.1%
4.0737	12	< 0.1%
4.3673	4	< 0.1%
4.4407	2	< 0.1%
3.7801	2	< 0.1%
1.1744	1	< 0.1%
0.7707	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.7707	1	< 0.1%
1.0276	166	0.1%
1.1744	1	< 0.1%
3.7801	2	< 0.1%
4.0737	12	< 0.1%

Value	Count	Frequency (%)
5.0279	325	0.2%
4.5141	191032	99.7%
4.4407	2	< 0.1%
4.3673	4	< 0.1%
4.2205	18	< 0.1%

account_creation_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	190383
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

2019-07-02 14:58:45	3
2019-07-01 01:21:10	3
2020-02-29 19:26:26	3
2019-12-28 16:35:34	3
2020-02-29 17:58:30	3
Other values (190378)	191548

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-07-02 14:58:45	3	< 0.1%
2019-07-01 01:21:10	3	< 0.1%
2020-02-29 19:26:26	3	< 0.1%
2019-12-28 16:35:34	3	< 0.1%
2020-02-29 17:58:30	3	< 0.1%
2019-06-30 14:47:57	3	< 0.1%
2019-10-26 12:15:45	2	< 0.1%
2019-08-15 18:32:54	2	< 0.1%
2019-07-04 17:04:47	2	< 0.1%
2020-01-06 13:05:15	2	< 0.1%
Other values (190373)	191537	> 99.9%

Frequencies of value counts

Unique

Unique	189209 ?
Unique (%)	98.8%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	19
Min length	19

trial_end_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	190383
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

2019-07-14 14:47:57	3
2020-01-11 16:35:34	3
2020-03-14 19:26:26	3
2019-07-16 14:58:45	3
2019-07-15 01:21:10	3
Other values (190378)	191548

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-07-14 14:47:57	3	< 0.1%
2020-01-11 16:35:34	3	< 0.1%
2020-03-14 19:26:26	3	< 0.1%
2019-07-16 14:58:45	3	< 0.1%
2019-07-15 01:21:10	3	< 0.1%
2020-03-14 17:58:30	3	< 0.1%
2019-07-29 22:13:18	2	< 0.1%
2019-07-18 18:39:31	2	< 0.1%
2019-11-20 03:40:21	2	< 0.1%
2020-03-12 15:11:11	2	< 0.1%
Other values (190373)	191537	> 99.9%

Frequencies of value counts

Unique

Unique	189209 ?
Unique (%)	98.8%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	19
Min length	19

initial_credit_card_declined
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	187.1 KiB

False	180451
True	11112

Common Values
Chart

Value	Count	Frequency (%)
False	180451	94.2%
True	11112	5.8%

join_fee
Real number (ℝ)

ZEROS

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1152957006
Minimum	-0.6606
Maximum	0.734
Zeros	33089
Zeros (%)	17.3%
Memory size	1.5 MiB

Quantile statistics

Minimum	-0.6606
5-th percentile	0
Q1	0.0367
median	0.0367
Q3	0.1101
95-th percentile	0.6606
Maximum	0.734
Range	1.3946
Interquartile range (IQR)	0.0734

Descriptive statistics

Standard deviation	0.1770207005
Coefficient of variation (CV)	1.535362546
Kurtosis	3.123783389
Mean	0.1152957006
Median Absolute Deviation (MAD)	0
Skewness	2.024318696
Sum	22086.3903
Variance	0.03133632839
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0.0367	108927	56.9%
0	33089	17.3%
0.3303	25200	13.2%
0.6606	12219	6.4%
0.1101	10617	5.5%
0.367	1328	0.7%
0.1835	146	0.1%
-0.0367	9	< 0.1%
0.6973	8	< 0.1%
0.6239	6	< 0.1%
Other values (10)	14	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.6606	2	< 0.1%
-0.3303	1	< 0.1%
-0.1101	1	< 0.1%
-0.0367	9	< 0.1%
0	33089	17.3%

Value	Count	Frequency (%)
0.734	1	< 0.1%
0.6973	8	< 0.1%
0.6606	12219	6.4%
0.6239	6	< 0.1%
0.5872	1	< 0.1%

payment_type
Categorical

MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	134856
Missing (%)	70.4%
Memory size	1.5 MiB

Standard Charter	22307
Paypal	17910
RAKBANK	10177
CBD	4194
Najim	2115

Frequencies
Length

Value	Count	Frequency (%)
Standard Charter	22307	11.6%
Paypal	17910	9.3%
RAKBANK	10177	5.3%
CBD	4194	2.2%
Najim	2115	1.1%
Apple Pay	4	< 0.1%
(Missing)	134856	70.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	16
Median length	3
Mean length	5.029008733
Min length	3

num_trial_days
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

14	191394
0	169

Frequencies
Length

Value	Count	Frequency (%)
14	191394	99.9%
0	169	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	1.999117784
Min length	1

current_sub_TF
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	187.1 KiB

True	105465
False	86098

Common Values
Chart

Value	Count	Frequency (%)
True	105465	55.1%
False	86098	44.9%

payment_period
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

0	84275
1	70204
2	34773
3	2311

Frequencies
Length

Value	Count	Frequency (%)
0	84275	44.0%
1	70204	36.6%
2	34773	18.2%
3	2311	1.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

last_payment
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	106702
Distinct (%)	99.5%
Missing	84275
Missing (%)	44.0%
Memory size	1.5 MiB

2020-03-08 19:00:43	3
2020-02-29 12:16:18	3
2020-03-14 19:26:26	3
2020-03-15 18:08:08	2
2020-03-15 12:43:15	2
Other values (106697)	107275

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-03-08 19:00:43	3	< 0.1%
2020-02-29 12:16:18	3	< 0.1%
2020-03-14 19:26:26	3	< 0.1%
2020-03-15 18:08:08	2	< 0.1%
2020-03-15 12:43:15	2	< 0.1%
2020-02-29 14:35:44	2	< 0.1%
2020-03-26 16:03:32	2	< 0.1%
2020-03-02 18:23:29	2	< 0.1%
2020-03-22 12:15:25	2	< 0.1%
2020-02-15 21:29:54	2	< 0.1%
Other values (106692)	107265	56.0%
(Missing)	84275	44.0%

Frequencies of value counts

Unique

Unique	106119 ?
Unique (%)	98.9%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	11.96106242
Min length	3

next_payment
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	104772
Distinct (%)	99.3%
Missing	86098
Missing (%)	44.9%
Memory size	1.5 MiB

2020-06-29 12:16:18	3
2020-07-08 19:00:43	3
2020-07-14 19:26:26	3
2020-07-25 15:36:42	2
2020-05-24 12:32:38	2
Other values (104767)	105452

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-06-29 12:16:18	3	< 0.1%
2020-07-08 19:00:43	3	< 0.1%
2020-07-14 19:26:26	3	< 0.1%
2020-07-25 15:36:42	2	< 0.1%
2020-05-24 12:32:38	2	< 0.1%
2020-04-30 15:23:34	2	< 0.1%
2020-04-21 02:03:47	2	< 0.1%
2020-04-15 02:54:00	2	< 0.1%
2020-03-30 14:39:34	2	< 0.1%
2020-06-12 02:52:49	2	< 0.1%
Other values (104762)	105442	55.0%
(Missing)	86098	44.9%

Frequencies of value counts

Unique

Unique	104082 ?
Unique (%)	98.7%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	11.80879919
Min length	3

cancel_date
Categorical

HIGH CARDINALITY
MISSING

Distinct	284
Distinct (%)	0.9%
Missing	159040
Missing (%)	83.0%
Memory size	1.5 MiB

2019-07-13 00:00:00	430
2019-07-12 00:00:00	391
2019-07-14 00:00:00	382
2019-07-15 00:00:00	346
2019-07-11 00:00:00	321
Other values (279)	30653

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-07-13 00:00:00	430	0.2%
2019-07-12 00:00:00	391	0.2%
2019-07-14 00:00:00	382	0.2%
2019-07-15 00:00:00	346	0.2%
2019-07-11 00:00:00	321	0.2%
2019-07-16 00:00:00	313	0.2%
2019-07-17 00:00:00	300	0.2%
2019-07-10 00:00:00	286	0.1%
2019-07-09 00:00:00	257	0.1%
2019-07-18 00:00:00	254	0.1%
Other values (274)	29243	15.3%
(Missing)	159040	83.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	19
Median length	3
Mean length	5.716432714
Min length	3

trial_completed
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	187.1 KiB

True	167235
False	24328

Common Values
Chart

Value	Count	Frequency (%)
True	167235	87.3%
False	24328	12.7%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	subid	package_type	num_weekly_services_utilized	preferred_genre	intended_use	weekly_consumption_hour	num_ideal_streaming_services	age	male_TF	attribution_technical	attribution_survey	op_sys	plan_type	monthly_price	discount_price	account_creation_date	trial_end_date	initial_credit_card_declined	join_fee	payment_type	num_trial_days	current_sub_TF	payment_period	last_payment	next_payment	cancel_date	trial_completed
0	1	23383224	base	NaN	comedy	access to exclusive content	22.951579	NaN	70.0	False	facebook	facebook	NaN	base_uae_14_day_trial	4.7343	4.5141	2020-03-01 15:44:35	2020-03-15 15:44:35	False	0.3303	NaN	14	True	1	2020-03-15 15:44:35	2020-07-15 15:44:35	NaN	True
1	2	26844789	enhanced	3.0	regional	replace OTT	36.001186	2.0	25.0	True	organic	facebook	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-12-07 16:37:06	2019-12-21 16:37:06	False	0.1101	NaN	14	False	0	NaN	NaN	NaN	True
2	3	29417030	base	NaN	drama	replace OTT	20.051667	NaN	30.0	False	search	tv	Android	base_uae_14_day_trial	4.7343	4.5141	2020-01-27 16:09:32	2020-02-10 16:09:32	False	0.0367	NaN	14	False	0	NaN	NaN	NaN	True
3	4	26723159	base	4.0	comedy	replace OTT	22.951579	3.0	28.0	False	discovery	youtube	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-10-05 12:57:07	2019-10-19 12:57:07	False	0.0367	NaN	14	True	2	2020-02-19 12:57:07	2020-06-19 12:57:07	NaN	True
4	5	24810928	base	NaN	comedy	access to exclusive content	20.051667	NaN	70.0	False	bing	tv	NaN	base_uae_14_day_trial	4.7343	4.5141	2020-03-03 20:15:43	2020-03-17 20:15:43	False	0.3303	RAKBANK	14	True	1	2020-03-17 20:15:43	2020-07-17 20:15:43	NaN	True
5	6	29726122	base	2.0	comedy	access to exclusive content	20.051667	2.0	61.0	False	bing	search	Android	base_uae_14_day_trial	4.7343	4.5141	2020-02-19 18:30:15	2020-03-04 18:30:15	False	0.3303	Standard Charter	14	True	1	2020-03-04 18:30:15	2020-07-04 18:30:15	NaN	True
6	7	20299962	base	3.0	drama	access to exclusive content	34.551230	2.0	23.0	False	email	referral	iOS	base_uae_14_day_trial	4.7343	4.5141	2020-03-05 14:52:22	2020-03-19 14:52:22	False	0.0000	RAKBANK	14	True	1	2020-03-19 14:52:22	2020-07-19 14:52:22	NaN	True
7	8	24930568	base	NaN	comedy	access to exclusive content	25.851492	NaN	73.0	False	facebook	facebook	iOS	base_uae_14_day_trial	4.7343	4.5141	2020-02-23 17:50:25	2020-03-08 17:50:25	False	0.6606	NaN	14	True	1	2020-03-08 17:50:25	2020-07-08 17:50:25	NaN	True
8	9	23452753	economy	3.0	drama	replace OTT	28.751405	2.0	71.0	False	search	facebook	Android	base_uae_14_day_trial	4.7343	4.5141	2020-01-21 14:17:53	2020-02-04 14:17:53	False	0.3303	NaN	14	False	0	NaN	NaN	2020-01-27 00:00:00	False
9	10	21191741	NaN	NaN	NaN	expand regional access	34.551230	NaN	53.0	True	organic	public_radio	NaN	base_uae_14_day_trial	4.7343	4.5141	2019-07-11 16:00:42	2019-07-25 16:00:42	False	0.0367	Standard Charter	14	False	1	2019-07-25 16:00:42	NaN	2019-08-20 00:00:00	True

Last rows

	df_index	subid	package_type	num_weekly_services_utilized	preferred_genre	intended_use	weekly_consumption_hour	num_ideal_streaming_services	age	male_TF	attribution_technical	attribution_survey	op_sys	plan_type	monthly_price	discount_price	account_creation_date	trial_end_date	initial_credit_card_declined	join_fee	payment_type	num_trial_days	current_sub_TF	payment_period	last_payment	next_payment	cancel_date	trial_completed
191553	227615	22117405	base	NaN	comedy	access to exclusive content	24.401536	NaN	30.0	False	youtube	facebook	NaN	base_uae_14_day_trial	4.7343	4.5141	2020-02-03 13:56:33	2020-02-17 13:56:33	False	0.0367	Paypal	14	True	1	2020-02-17 13:56:33	2020-06-17 13:56:33	NaN	True
191554	227616	26828621	base	4.0	drama	access to exclusive content	27.301448	2.0	44.0	False	email	facebook	iOS	base_uae_14_day_trial	4.7343	4.5141	2020-02-26 02:12:05	2020-03-11 02:12:05	False	0.0000	Standard Charter	14	True	1	2020-03-11 02:12:05	2020-07-11 02:12:05	NaN	True
191555	227618	22218943	economy	NaN	comedy	replace OTT	37.451142	NaN	67.0	True	brand sem intent bing	referral	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-11-16 02:53:50	2019-11-30 02:53:50	False	0.0367	NaN	14	False	0	NaN	NaN	2019-11-27 00:00:00	False
191556	227619	25492551	base	3.0	comedy	access to exclusive content	30.201361	2.0	32.0	False	email	facebook	Android	base_uae_14_day_trial	4.7343	4.5141	2019-09-30 22:07:37	2019-10-14 22:07:37	False	0.0000	NaN	14	True	2	2020-02-14 22:07:37	2020-06-14 22:07:37	NaN	True
191557	227621	25549852	enhanced	NaN	comedy	access to exclusive content	28.751405	NaN	61.0	False	affiliate	facebook	Android	base_uae_14_day_trial	4.7343	4.5141	2020-03-06 02:57:03	2020-03-20 02:57:03	False	0.3303	NaN	14	True	1	2020-03-20 02:57:03	2020-07-20 02:57:03	NaN	True
191558	227622	25835684	base	2.0	drama	access to exclusive content	24.401536	2.0	43.0	False	email	pinterest	iOS	base_uae_14_day_trial	4.7343	4.5141	2020-01-01 22:43:56	2020-01-15 22:43:56	False	0.0000	NaN	14	True	1	2020-01-15 22:43:56	2020-05-15 22:43:56	NaN	True
191559	227623	21434712	enhanced	3.0	comedy	supplement OTT	28.751405	2.0	38.0	False	facebook	facebook_organic	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-11-17 14:12:33	2019-12-01 14:12:33	False	0.3303	NaN	14	True	1	2019-12-01 14:12:33	2020-04-01 14:12:33	NaN	True
191560	227624	25843074	enhanced	2.0	comedy	replace OTT	27.301448	2.0	49.0	False	google_organic	referral	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-12-06 18:02:13	2019-12-20 18:02:13	False	0.3303	Paypal	14	True	1	2019-12-20 18:02:13	2020-04-20 18:02:13	NaN	True
191561	227625	24799085	base	NaN	comedy	access to exclusive content	31.651317	NaN	45.0	False	facebook	facebook	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-12-21 19:40:44	2020-01-04 19:40:44	True	0.0367	NaN	14	True	1	2020-01-04 19:40:44	2020-05-04 19:40:44	NaN	True
191562	227627	20166335	base	NaN	comedy	replace OTT	25.851492	NaN	55.0	False	organic	tv	iOS	base_uae_14_day_trial	4.7343	4.5141	2019-11-26 19:09:09	2019-12-10 19:09:09	False	0.0367	NaN	14	False	0	NaN	NaN	2019-12-09 00:00:00	False

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows